Setup & Administration

Five navigation menus, a source data query and two data management queries may need to be created for the Haul Analysis process.

Navigation Menus

The table below lists the navigation menus that can be used for Haul Analysis.

Menu	Description
Haul Analysis	The parent menu to place the related Haul Analysis menus. Typically this would be a Dashboard Tile page type where charts relating to Haul Analysis can be placed.
Configuration	The configuration menu contains the Haul Analysis Category data that is used by the Haul Analysis process. It defines the data query which determines the filters and outputs to be used, and the data management queries to be used for the management of distances. These distance may be automatically retrieved from a fleet management system or manually entered. It is possible to define 10 distance fields. The mapping of the automatically retrieved distances to the defined distances occurs here, as does the mapping of the Survey Source and Destination fields for the manually entered survey distances.
Manage Survey Distances	The manage survey distances menu is used for the manual entry of surveyed distances for a defined source and destination combination. A list may be exported for the source and destination combination for survey to enter the calculated distance, which can then be imported into MiiNT and used when the distances are managed. This menu is optional.
Manage Distances	The aim of the Manage Survey Distance process is to create haulage data that has been extended with distance data, which can then be used as part of reporting for various analyses and costing activities. This survey distance data may be automatically retrieved from a fleet management system or manually entered.
Import Survey Distances	The import survey distances menu will be used for the importing of calculated survey distances.

Source Data Query

A data query needs to be created to provided the source data and to determine the filters and outputs for the data. This source data query will be placed in the Data Query field on the Configuration page.

GPS Coordinates

The table below displays an example of the source data query when the distances are retrieved automatically from a Fleet Management System.

Data Query for Automatic Retrieval	Description
Table	This must be set to Load & Haul table.
Filters
Date	The filter must be named Date. The date range is used to filter the data by the selected period.
Outputs
Haul Id	The id of the haulage movement.
Time Full	The time that the equipment used for the movement was full. This field is mandatory for automatic retrieval and would be mapped to the Load & Haul table.
Time Empty	The time that the equipment used for the movement was emptied. This field is mandatory for automatic retrieval and would be mapped to the Load & Haul table.
Horizontal Distance	A horizontal distance measurement field that has been mapped to the Load & Haul table. There may be up to 10 of these distance measurement fields.
Vertical Distance Up	A vertical distance up measurement field that has been mapped to the Load & Haul table.There may be up to 10 of these distance measurement fields.
Vertical Distance Down	A vertical distance down measurement field that has been mapped to the Load & Haul table.There may be up to 10 of these distance measurement fields.

Use Query Builder to create the query.

Surveyed Distances

The table below displays an example of the source data query when the distances are manually entered.

Data Query for Automatic Retrieval	Description
Table	This must be set to Load & Haul table.
Filters
Date	The filter must be named Date. The date range is used to filter the data by the selected period.
Outputs
Haul Id	The id of the haulage movement.
Source	The source of the movement, in conjunction with the destination that the manually entered destinations apply to. An example of the source may be the concatenation of the pit and shot ie PitA_
Destination	The time that the equipment used for the movement was emptied. This field is mandatory for automatic retrieval and would be mapped to the Load & Haul table.

Use Query Builder to create the query.